﻿CREATE TABLE [dbo].[SheetHistory] (
    [id]      INT            IDENTITY (1, 1) NOT NULL,
    [SheetId] INT            NOT NULL,
    [OpId]    INT            NOT NULL,
    [OperId]  INT            NOT NULL,
    [OpDate]  DATETIME       NOT NULL,
    [remark]  NVARCHAR (500) NULL,
    CONSTRAINT [PK__SheetHis__3213E83F22AA2996] PRIMARY KEY CLUSTERED ([id] ASC) WITH (FILLFACTOR = 100)
);




GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'备注', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'SheetHistory', @level2type = N'COLUMN', @level2name = N'remark';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'操作时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'SheetHistory', @level2type = N'COLUMN', @level2name = N'OpDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'操作者id', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'SheetHistory', @level2type = N'COLUMN', @level2name = N'OperId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'操作编号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'SheetHistory', @level2type = N'COLUMN', @level2name = N'OpId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'工单号id', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'SheetHistory', @level2type = N'COLUMN', @level2name = N'SheetId';

